1
2 <?php
3 include_once 'header.php';
4 ?>
5 <html>
6 <head>
7 <title>Signup</title>
8 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
9
10 <!-- Optional theme -->
11 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
12
13 <!-- Latest compiled and minified JavaScript -->
14 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
15 </head>
16
17 <style>
18 table,th,td
19 {
20 border: 2px color: transparent;
21 font-family: monospace;
22 font-size: 150%;
23 padding: 0.25cm;
24 background-color: white;
25
26 }
27 body{
28 background-image: url("images/neram.jpg");
29 -moz-background-size: cover;
30 -webkit-background-size: cover;
31 background-size: cover;
32 background-position: top center !important;
33 background-repeat: no-repeat !important;
34 background-attachment: fixed;
35 color: black;
36 }
37 button
38 {
39 display: block;
40 margin: 0 auto;
41 width: 10%;
42 height: 40px;
43 border: none;
44 background-color: #222;
45 font-family: arial;
46 font-size: 16px;
47 color: #fff;
48 cursor: pointer;
49 }
50 </style>
51
52 <head>
53 <h1 align="middle" style="font-size: 500%;"><u>Neram</u></h1>
54 </head>
55
56
57 <body style="background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
58 <h1> </h1>
59 <p align=middle>
60 <video width="700" height="545" controls >
61 <source src="video/neram.mp4" type="video/mp4">
62 </video>
63 <h1 align="middle" style="font-size: 300%;"><u><b>Trailer</b></u></h1>
64 </p>
65
66 <br><br><br><br>
67
68 <?php
69 $dbServername = "localhost";
70 $dbUsername = "root";
71 $dbPassword = "password";
72 $dbName = "test";
73
74 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
75
76 $sql="SELECT description,genre,mov_lang,dir_name,stars from movie m,director d,rating r where d.dir_id=m.dir_id and r.mov_id=m.mov_id and mov_name='Neram'; ";
77 mysqli_query($conn, $sql) or die('Error');
78 $result = mysqli_query($conn, $sql);
79 while($row=mysqli_fetch_array($result))
80 {
81 echo '<table style="margin-left:20%; margin-right:20%;">
82
83 <tr>
84 <td><u> <b>Description</b></u></td>
85 <td>'.$row['description'].'</td>
86 </tr>
87 <tr>
88 <td><u><b> Genre</b></u></td>
89 <td>'.$row['genre'].'</td>
90 </tr>
91 <tr>
92 <td><u><b> Language</b> </u></td>
93 <td>'.$row['mov_lang'].'</td>
94 </tr>
95 <tr>
96 <td><u> <b>Director</b> </u></td>
97 <td>'.$row['dir_name'].'</td>
98 </tr>
99 <tr>
100 <td><u><b>Rating</b> </u></td>
101 <td>'.$row['stars'].'</td>
102 </tr>
103 </table><br><br><br>';
104 }
105 ?>
106
107 <h1 align="middle" style="font-size: 300%;"><u><b>Cast</b></u></h1>
108
109 <?php
110 $sql1="SELECT actor_name,role from actor a,movie m,movie_cast mc where a.actor_id=mc.actor_id and mc.mov_id=m.mov_id and m.mov_name='Neram';";
111 mysqli_query($conn, $sql) or die('Error');
112 $result1 = mysqli_query($conn, $sql1);
113 echo '<br><table style="margin-left: auto; margin-right: auto;">
114 <tr align="middle">
115 <td><u><b>Actor</b></u></td>
116 <td><u><b>Role</b></u></td>
117 </tr>';
118 while($row=mysqli_fetch_array($result1))
119 {
120 echo '<tr>
121 <td>'.$row['actor_name'].'</td>
122 <td align="middle">'.$row['role'].'</td>
123 </tr>';
124 }
125
126 echo '</table><br><br><br>';
127
128 $_SESSION['mov_name']="Neram";
129
130 ?>
131
132 <center><a href="nowshowing.php" class="btn btn-default btn-lg" style="font-size:15px padding-top:0.25%; font-family: comic sans ms; color: black" role="button"><b>Book now</b></a></center><br>
133
134 </body>
135
136 </html>
137 <?php
138 include_once 'footer.php';
139 ?>